284Uploads
2081k+Views
2046k+Downloads
Whole school
2017 KS2 National Curriculum Test for Grammar, Punctuation and Spelling Electronic Analysis
With individual pupil reporting for up to 550 pupils
Works best in Excel 2010 or later with macros enabled
New features for the 2017 version include Age Related Expectations reporting and improved presentation of graphs
2023 KS1 SATs Grammar, Punctuation and Spelling Test and Question Level Analysis
2023 KS1 Grammar, Punctuation and Spelling Test and Question Level Analysis
Requires Excel with macros enabled.
Summary of Features (please note some features may not be available depending on the test type):
Pupil Summary shows total marks for each paper, number of questions unanswered (possibly indicating need to increase pace), number of incorrect answers, total overall score (and percent), total score in each strand. Option to adjust the colour thresholds to make it easier to spot patterns and gaps.
Pupil Reports show a summary of performance in each strand for an individual pupils. Useful for feeding back to pupils, parents and informing intervention teachers.
Contextual Analysis shows a breakdown by key groups (gender, SEND status, disadvantaged, EAL) plus up to four custom groups. Compares school data (grades and scaled scores) to national data in a detailed but user-friendly report.
Cohort Summary shows an overview of the cohort against each strand. This is also compared to national data where it is available. This page gives a summary of attainment including number and percent at expected and higher standard.
Strand Summary shows a the weighting of each strand and the performance within it. For example, in a grammar test a cohort may perform poorly in identifying sentence types and equally poorly in identifying punctuation. However as there is more weighting given to punctuation, it would be advisable to focus on this area.
Other Charts Charts which show performance for each question, organised by most correct to incorrect, by strand and also by year group question (for mathematics). The most powerful chart orders questions from most correct to incorrect enabling you to see precisely where there are strengths and weaknesses.
2018 KS1 National Curriculum (SATs) Test Analysis for Mathematics
2018 KS1 National Curriculum (SATs) Test Analysis for Mathematics.
Please see release notes for new features.
Analysis for all tests is available elsewhere on TES or from our website.
2018 KS1 National Curriculum (SATs) Test Analysis for Grammar, Punctuation and Spelling.
2018 KS1 National Curriculum (SATs) Test Analysis for Grammar, Punctuation and Spelling.
Please see release notes for new features.
Analysis for all tests is available elsewhere on TES or from our website.
2022 KS1 SATs Grammar, Punctuation and Spelling Test and Question Level Analysis
2022 KS1 Grammar, Punctuation and Spelling Test and Question Level Analysis
Requires Excel with macros enabled.
Summary of Features (please note some features may not be available depending on the test type):
Pupil Summary shows total marks for each paper, number of questions unanswered (possibly indicating need to increase pace), number of incorrect answers, total overall score (and percent), total score in each strand. Option to adjust the colour thresholds to make it easier to spot patterns and gaps.
Pupil Reports show a summary of performance in each strand and per question for an individual pupils. Useful for feeding back to pupils, parents and informing intervention teachers.
Contextual Analysis shows a breakdown by key groups (gender, SEND status, disadvantaged, EAL) plus up to four custom groups. Compares school data (grades and scaled scores) to national data in a detailed but user-friendly report.
Cohort Summary shows an overview of the cohort against each strand. This is also compared to national data where it is available. This page gives a summary of attainment including number and percent at expected and higher standard.
Strand Summary shows a the weighting of each strand and the performance within it. For example, in a grammar test a cohort may perform poorly in identifying sentence types and equally poorly in identifying punctuation. However as there is more weighting given to punctuation, it would be advisable to focus on this area.
Other Charts Charts which show performance for each question, organised by most correct to incorrect, by strand and also by year group question (for mathematics). The most powerful chart orders questions from most correct to incorrect enabling you to see precisely where there are strengths and weaknesses.
2019 KS1 Mathematics Question Level Analysis
Summary of Features (please note some features may not be available depending on the test type):
Pupil Summary shows total marks for each paper, number of questions unanswered (possibly indicating need to increase pace), number of incorrect answers, total overall score (and percent), total score in each strand. Option to adjust the colour thresholds to make it easier to spot patterns and gaps.
Pupil Reports show a summary of performance in each strand for an individual pupils. Available in 2017 versions and later excluding reading. 2018 versions and later contain detailed feedback on each question. Useful for feeding back to pupils, parents and informing intervention teachers.
Cohort Summary shows an overview of the cohort against each strand. This is also compared to national data where it is available. This page gives a summary of attainment including number and percent at expected and higher standard.
Strand Summary shows a the weighting of each strand and the performance within it. For example, in a grammar test a cohort may perform poorly in identifying sentence types and equally poorly in identifying punctuation. However as there is more weighting given to punctuation, it would be advisable to focus on this area.
Other Charts Charts which show performance for each question, organised by most correct to incorrect, by strand and also by year group question (for mathematics). The most powerful chart orders questions from most correct to incorrect enabling you to see precisely where there are strengths and weaknesses.
2019 KS1 Grammar, Punctuation & Spelling Test and Question Level Analysis
Summary of Features (please note some features may not be available depending on the test type):
Pupil Summary shows total marks for each paper, number of questions unanswered (possibly indicating need to increase pace), number of incorrect answers, total overall score (and percent), total score in each strand. Option to adjust the colour thresholds to make it easier to spot patterns and gaps.
Pupil Reports show a summary of performance in each strand for an individual pupils. Available in 2017 versions and later excluding reading. 2018 versions and later contain detailed feedback on each question. Useful for feeding back to pupils, parents and informing intervention teachers.
Cohort Summary shows an overview of the cohort against each strand. This is also compared to national data where it is available. This page gives a summary of attainment including number and percent at expected and higher standard.
Strand Summary shows a the weighting of each strand and the performance within it. For example, in a grammar test a cohort may perform poorly in identifying sentence types and equally poorly in identifying punctuation. However as there is more weighting given to punctuation, it would be advisable to focus on this area.
Other Charts Charts which show performance for each question, organised by most correct to incorrect, by strand and also by year group question (for mathematics). The most powerful chart orders questions from most correct to incorrect enabling you to see precisely where there are strengths and weaknesses.
2017 KS2 National Curriculum Test for Mathematics Electronic Analysis
New features for the 2017 version include Age Related Expectations reporting and improved presentation of graphs.
Paper 1 Arithmetic (up to 250 pupils)
Papers 2 & 3 Reasoning: Up to 1000 pupils with individual pupil reporting
Works best in Excel 2010 or later with macros enabled
2018 KS2 National Curriculum (SATs) Test Analysis for Grammar, Punctuation and Spelling
2018 KS2 National Curriculum (SATs) Test Analysis for Grammar, Punctuation and Spelling.
Please see release notes for new features.
Analysis for all tests is available elsewhere on TES or from our website.
2024 KS1 Mathematics Question Level Analysis
2024 KS1 Mathematics Question Level Analysis
Requires Excel with macros enabled.
Instant download after purchase. Maximum of 5 downloads.
Please note sample pictures are for the KS2 Mathematics Analysis.
Summary of Features (please note some features may not be available depending on the test type):
Pupil Summary shows total marks for each paper, number of questions unanswered (possibly indicating need to increase pace), number of incorrect answers, total overall score (and percent), total score in each strand. Option to adjust the colour thresholds to make it easier to spot patterns and gaps.
Pupil Reports show a summary of performance in each strand for an individual pupils. Available in 2016 versions and later. Useful for feeding back to pupils, parents and informing intervention teachers.
Contextual Analysis (2019 versions onwards) shows a breakdown by key groups (gender, SEND status, disadvantaged, EAL) plus up to four custom groups. Compares school data (grades and scaled scores) to national data in a detailed but user-friendly report.
Cohort Summary shows an overview of the cohort against each strand. This is also compared to national data where it is available. This page gives a summary of attainment including number and percent at expected and higher standard.
Strand Summary shows a the weighting of each strand and the performance within it. For example, in a grammar test a cohort may perform poorly in identifying sentence types and equally poorly in identifying punctuation. However as there is more weighting given to punctuation, it would be advisable to focus on this area.
Other Charts Charts which show performance for each question, organised by most correct to incorrect, by strand and also by year group question (for mathematics). The most powerful chart orders questions from most correct to incorrect enabling you to see precisely where there are strengths and weaknesses.
2024 KS1 Mathematics Question Level Analysis (SATs)
2023 KS1 SATs Mathematics Test and Question Level Analysis
2023 KS1 Mathematics Test and Question Level Analysis
Requires Excel with macros enabled.
Summary of Features (please note some features may not be available depending on the test type):
Pupil Summary shows total marks for each paper, number of questions unanswered (possibly indicating need to increase pace), number of incorrect answers, total overall score (and percent), total score in each strand. Option to adjust the colour thresholds to make it easier to spot patterns and gaps.
Pupil Reports show a summary of performance in each strand and per question for an individual pupils. Useful for feeding back to pupils, parents and informing intervention teachers.
Contextual Analysis shows a breakdown by key groups (gender, SEND status, disadvantaged, EAL) plus up to four custom groups. Compares school data (grades and scaled scores) to national data in a detailed but user-friendly report.
Cohort Summary shows an overview of the cohort against each strand. This is also compared to national data where it is available. This page gives a summary of attainment including number and percent at expected and higher standard.
Strand Summary shows a the weighting of each strand and the performance within it. For example, in a grammar test a cohort may perform poorly in identifying sentence types and equally poorly in identifying punctuation. However as there is more weighting given to punctuation, it would be advisable to focus on this area.
Other Charts Charts which show performance for each question, organised by most correct to incorrect, by strand and also by year group question (for mathematics). The most powerful chart orders questions from most correct to incorrect enabling you to see precisely where there are strengths and weaknesses.
2019 KS2 Grammar, Punctuation & Spelling Test and Question Level Analysis
Summary of Features (please note some features may not be available depending on the test type):
Pupil Summary shows total marks for each paper, number of questions unanswered (possibly indicating need to increase pace), number of incorrect answers, total overall score (and percent), total score in each strand. Option to adjust the colour thresholds to make it easier to spot patterns and gaps.
Pupil Reports show a summary of performance in each strand for an individual pupils. Available in 2017 versions and later excluding reading. 2018 versions and later contain detailed feedback on each question. Useful for feeding back to pupils, parents and informing intervention teachers.
Cohort Summary shows an overview of the cohort against each strand. This is also compared to national data where it is available. This page gives a summary of attainment including number and percent at expected and higher standard.
Strand Summary shows a the weighting of each strand and the performance within it. For example, in a grammar test a cohort may perform poorly in identifying sentence types and equally poorly in identifying punctuation. However as there is more weighting given to punctuation, it would be advisable to focus on this area.
Other Charts Charts which show performance for each question, organised by most correct to incorrect, by strand and also by year group question (for mathematics). The most powerful chart orders questions from most correct to incorrect enabling you to see precisely where there are strengths and weaknesses.
2022 KS1 SATs Mathematics Test and Question Level Analysis
2022 KS1 Mathematics Test and Question Level Analysis
Requires Excel with macros enabled.
Summary of Features (please note some features may not be available depending on the test type):
Pupil Summary shows total marks for each paper, number of questions unanswered (possibly indicating need to increase pace), number of incorrect answers, total overall score (and percent), total score in each strand. Option to adjust the colour thresholds to make it easier to spot patterns and gaps.
Pupil Reports show a summary of performance in each strand and per question for an individual pupils. Useful for feeding back to pupils, parents and informing intervention teachers.
Contextual Analysis shows a breakdown by key groups (gender, SEND status, disadvantaged, EAL) plus up to four custom groups. Compares school data (grades and scaled scores) to national data in a detailed but user-friendly report.
Cohort Summary shows an overview of the cohort against each strand. This is also compared to national data where it is available. This page gives a summary of attainment including number and percent at expected and higher standard.
Strand Summary shows a the weighting of each strand and the performance within it. For example, in a grammar test a cohort may perform poorly in identifying sentence types and equally poorly in identifying punctuation. However as there is more weighting given to punctuation, it would be advisable to focus on this area.
Other Charts Charts which show performance for each question, organised by most correct to incorrect, by strand and also by year group question (for mathematics). The most powerful chart orders questions from most correct to incorrect enabling you to see precisely where there are strengths and weaknesses.
2018 KS2 National Curriculum (SATs) Test Analysis for Mathematics
2018 KS2 National Curriculum (SATs) Test Analysis for Mathematics.
Please see release notes for new features.
Analysis for all tests is available elsewhere on TES or form our website.
2022 KS2 Grammar, Punctuation & Spelling Test and Question Level Analysis
2022 KS2 Grammar, Punctuation & Spelling Test and Question Level Analysis
Requires Excel with macros enabled.
Summary of Features:
Questions Versus National compares the performance of your cohort against the performance of pupils nationally in each question. A powerful chart which instantly shows you which questions you are strong or weak on. As it uses national data, it considers the difficulty of each question, compares it the performance of your cohort and orders the results from strongest to weakest. 2016 to 2022 KS2 versions only, Q vs National will be added to the 2023 KS2 version at a later date.
Pupil Summary shows total marks for each paper, number of questions unanswered (possibly indicating need to increase pace), number of incorrect answers, total overall score (and percent), total score in each strand. Option to adjust the colour thresholds to make it easier to spot patterns and gaps.
Pupil Reports show a summary of performance in each strand for an individual pupils. Available in 2017 versions and later excluding reading. 2018 versions and later contain detailed feedback on each question. Useful for feeding back to pupils, parents and informing intervention teachers.
Contextual Analysis (2019 versions onwards) shows a breakdown by key groups (gender, SEND status, disadvantaged, EAL) plus up to four custom groups. Compares school data (grades and scaled scores) to national data in a detailed but user-friendly report.
Cohort Summary shows an overview of the cohort against each strand. This is also compared to national data where it is available. This page gives a summary of attainment including number and percent at expected and higher standard.
Strand Summary shows the weighting of each strand and the performance within it. For example, in a grammar test a cohort may perform poorly in identifying sentence types and equally poorly in identifying punctuation. However as there is more weighting given to punctuation, it would be advisable to focus on this area.
Other Charts Charts which show performance for each question, organised by most correct to incorrect, by strand and also by year group question (for mathematics). The most powerful chart orders questions from most correct to incorrect enabling you to see precisely where there are strengths and weaknesses.
2022 KS2 Grammar, Punctuation & Spelling Test and Question Level Analysis
2019 KS2 Mathematics Question Level Analysis
Summary of Features (please note some features may not be available depending on the test type):
Pupil Summary shows total marks for each paper, number of questions unanswered (possibly indicating need to increase pace), number of incorrect answers, total overall score (and percent), total score in each strand. Option to adjust the colour thresholds to make it easier to spot patterns and gaps.
Pupil Reports show a summary of performance in each strand for an individual pupils. Available in 2017 versions and later excluding reading. 2018 versions and later contain detailed feedback on each question. Useful for feeding back to pupils, parents and informing intervention teachers.
Cohort Summary shows an overview of the cohort against each strand. This is also compared to national data where it is available. This page gives a summary of attainment including number and percent at expected and higher standard.
Strand Summary shows a the weighting of each strand and the performance within it. For example, in a grammar test a cohort may perform poorly in identifying sentence types and equally poorly in identifying punctuation. However as there is more weighting given to punctuation, it would be advisable to focus on this area.
Other Charts Charts which show performance for each question, organised by most correct to incorrect, by strand and also by year group question (for mathematics). The most powerful chart orders questions from most correct to incorrect enabling you to see precisely where there are strengths and weaknesses.
Rapid Reading - 49 Quick Reading Activities for Upper Key Stage 2
Quick comprehensions designed to last up to 10 minutes. Based on texts from previous curriculum texts including new and original questions. Answers also included.
3 different levels of text
Categorised questions
Sample file can be found here:
https://www.tes.com/teaching-resource/rapid-reading-49-quick-reading-activities-for-upper-key-stage-2-11222572
Rapid Grammar - 49 Quick Grammar, Punctuation and Vocabulary Activities for Upper Key Stage 2
Rapid Grammar - 49 Quick Grammar, Punctuation and Vocabulary Activities for Upper Key Stage 2
Quick activities designed to last up to 10 minutes. Based on the 2016 test framework for grammar in Key Stage 2. Includes new and original questions.
Categorised questions.
Answers also included.
Sample file containing 3 of the 49 activities can be found here:
https://www.tes.com/teaching-resource/rapid-grammar-49-quick-grammar-punctuation-and-vocabulary-activities-for-upper-key-stage-2-11223951
Rapid Reading - 48 Quick Reading Activities for Lower Key Stage 2
Quick comprehensions designed to last up to 10 minutes. Based on texts from previous curriculum tests including new and original questions. Answers also included.
3 different levels of text
Categorised questions
2022 KS2 Mathematics Test and Question Level Analysis
2022 KS2 Mathematics Test and Question Level Analysis
Requires Excel with macros enabled.
Summary of Features (please note some features may not be available depending on the test type):
Questions Versus National compares the performance of your cohort against the performance of pupils nationally in each question. A powerful chart which instantly shows you which questions you are strong or weak on. As it uses national data, it considers the difficulty of each question, compares it the performance of your cohort and orders the results from strongest to weakest. 2016 to 2022 KS2 versions only, Q vs National will be added to the 2023 KS2 version at a later date.
Pupil Summary shows total marks for each paper, number of questions unanswered (possibly indicating need to increase pace), number of incorrect answers, total overall score (and percent), total score in each strand. Option to adjust the colour thresholds to make it easier to spot patterns and gaps.
Pupil Reports show a summary of performance in each strand for an individual pupils. Available in 2017 versions and later excluding reading. 2018 versions and later contain detailed feedback on each question. Useful for feeding back to pupils, parents and informing intervention teachers.
Contextual Analysis (2019 versions onwards) shows a breakdown by key groups (gender, SEND status, disadvantaged, EAL) plus up to four custom groups. Compares school data (grades and scaled scores) to national data in a detailed but user-friendly report.
Cohort Summary shows an overview of the cohort against each strand. This is also compared to national data where it is available. This page gives a summary of attainment including number and percent at expected and higher standard.
Strand Summary shows a the weighting of each strand and the performance within it. For example, in a grammar test a cohort may perform poorly in identifying sentence types and equally poorly in identifying punctuation. However as there is more weighting given to punctuation, it would be advisable to focus on this area.
Other Charts Charts which show performance for each question, organised by most correct to incorrect, by strand and also by year group question (for mathematics). The most powerful chart orders questions from most correct to incorrect enabling you to see precisely where there are strengths and weaknesses.
2022 KS2 Mathematics Test and Question Level Analysis